-- #lazgen HEADER#
/*
	spGoalRequiredExpertiseGet.

	This procedure returns a single GoalRequiredExpertise from the database, based on a specific primary key value.
*/
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [spGoalRequiredExpertiseGet]
(		
	@id INT

) AS
		
BEGIN
-- #endlazgen HEADER#

-- #lazgen BODY#

SELECT
	[goalrequiredexpertise].[Id],
	[goalrequiredexpertise].[GoalId],
	[goalrequiredexpertise].[TechnologyId],
	[goalrequiredexpertise].[Created],
	[goalrequiredexpertise].[Modified]
FROM
	[tblGoalRequiredExpertise] [goalrequiredexpertise]
WHERE
	[goalrequiredexpertise].[Id] = @id

-- #endlazgen BODY#


-- #lazgen FOOTER#

END

GO

SET ANSI_NULLS OFF
GO   
-- #endlazgen FOOTER#
